Interview Questions and Answer
Options:
a. REFRESH CUBECube_Name
b. REFRESH CUBE ‘Cube_Name’
c. REFRESH CUBE “Cube_Name”
d. REFRESH CUBE \Cube_Name\
Reveal Answer
Options:
a. Using BIDS
b. Using SSMS
c. Using XMLA
d. All the above
Reveal Answer
Options:
a. A weight expression should be expressed as a decimal value between zero (0) and 1
b. Each UPDATE CUBE allocation should be considered to be atomic for transactional purposes
c. When updated cells overlap, the Update Isolation Level connection string property can be used to enhance performance for UPDATE CUBE
d. None of the mentioned
Reveal Answer
Options:
a. Only dropping the default member is supported in MDX Scripting
b. In the SELECT statement, the FROM clause determines the cube context
c. Very few cubes can control how errors within a Multidimensional Expressions (MDX) script are handled
d. None of the mentioned
Reveal Answer
Options:
a. Referenced Relationship
b. Fact Relationship
c. Regular Relationship
d. None of these
Reveal Answer
Options:
a. Additive
b. Non-additive
c. Semi-Additive
d. None of these
Reveal Answer
Bestdotnet google plus